Interview Questions and Answers for 'Jibe development services' - 3 question(s) found - Order By Newest Q1. Write a SQL to find max salary by Dept SQL
Ans. SELECT MAX(SALARY),DEPT FROM EMPLOYEE GROUP BY DEPT Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve   Asked in 1 Companies Related Questions What are Inner , Outer , Left and Right Joins in SQL ? What is JDBC? Describe the steps needed to execute a SQL query using JDBC. What are temp tables ? What is a self Join and give an example of a self Join ?
or
What is self Join and What is it's purpose ? Do you like Native SQL Apis like JDBC or JPA / Hibernate ? Is there any schema in mongo DB ? Difference between Inner and Outer Join ? What is a Cursor ? Does SQL allow null values ? Can we use it within Where clause ? Write an SQL to find all records having all upper case alphanumeric characters in a field ? Q2. What is a composite primary key and foreign key ? Database
Ans. The combination of values from multiple columns in the composite primary key must be unique for each row in the table.
A foreign key, on the other hand, is a field or set of fields in one table that refers to the primary key in another table. It establishes a relationship between two tables based on the values of the foreign key and the primary key. Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve   Asked in 1 Companies Related Questions Difference between == and .equals() ? Why is String immutable in Java ? Explain the scenerios to choose between String , StringBuilder and StringBuffer ?
or
What is the difference between String , StringBuilder and StringBuffer ? What are the difference between composition and inheritance in Java? Explain OOPs
or
Explain OOPs Principles
or
Explain OOPs Concepts
or
Explain OOPs features
or
Tell me something about OOPs What is a Lambda Expression ? What's its use ? Why Char array is preferred over String for storing password? What are different ways to create String Object? Explain. Does garbage collection guarantee that a program will not run out of memory? What is the difference between final, finally and finalize() ? Q3. What is ado.net ? C#
This question was recently asked at 'jibe development services'.This question is still unanswered. Can you please provide an answer. Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve   Asked in 1 Companies Related Questions Difference between == and .equals() ? Why is String immutable in Java ? Explain the scenerios to choose between String , StringBuilder and StringBuffer ?
or
What is the difference between String , StringBuilder and StringBuffer ? What are the difference between composition and inheritance in Java? Explain OOPs
or
Explain OOPs Principles
or
Explain OOPs Concepts
or
Explain OOPs features
or
Tell me something about OOPs What is a Lambda Expression ? What's its use ? Why Char array is preferred over String for storing password? What are different ways to create String Object? Explain. Does garbage collection guarantee that a program will not run out of memory? What is the difference between final, finally and finalize() ?